package com.websql.yousql.dao;

import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

@Mapper
public interface ConnectionDao {

    @Select("select id from connection where user_id = #{userId} and conn_host = #{host} and conn_port = #{port};")
    String getIdByUserAndIp(@Param("userId") Integer userId,@Param("host") String host,@Param("port") String port);

}
